class AddCountries < ActiveRecord::Migration
  def self.up
      sql_code = <<-END
    TRUNCATE `countries`;
INSERT INTO `countries` VALUES (1, 'United States');
INSERT INTO `countries` VALUES (2, 'Canada');
INSERT INTO `countries` VALUES (3, 'Mexico');
INSERT INTO `countries` VALUES (4, 'Afghanistan');
INSERT INTO `countries` VALUES (5, 'Albania');
INSERT INTO `countries` VALUES (6, 'Algeria');
INSERT INTO `countries` VALUES (7, 'Andorra');
INSERT INTO `countries` VALUES (8, 'Angola');
INSERT INTO `countries` VALUES (9, 'Anguilla');
INSERT INTO `countries` VALUES (10, 'Antarctica');
INSERT INTO `countries` VALUES (11, 'Antigua and Barbuda');
INSERT INTO `countries` VALUES (12, 'Argentina');
INSERT INTO `countries` VALUES (13, 'Armenia');
INSERT INTO `countries` VALUES (14, 'Aruba');
INSERT INTO `countries` VALUES (15, 'Ascension Island');
INSERT INTO `countries` VALUES (16, 'Australia');
INSERT INTO `countries` VALUES (17, 'Austria');
INSERT INTO `countries` VALUES (18, 'Azerbaijan');
INSERT INTO `countries` VALUES (19, 'Bahamas');
INSERT INTO `countries` VALUES (20, 'Bahrain');
INSERT INTO `countries` VALUES (21, 'Bangladesh');
INSERT INTO `countries` VALUES (22, 'Barbados');
INSERT INTO `countries` VALUES (23, 'Belarus');
INSERT INTO `countries` VALUES (24, 'Belgium');
INSERT INTO `countries` VALUES (25, 'Belize');
INSERT INTO `countries` VALUES (26, 'Benin');
INSERT INTO `countries` VALUES (27, 'Bermuda');
INSERT INTO `countries` VALUES (28, 'Bhutan');
INSERT INTO `countries` VALUES (29, 'Bolivia');
INSERT INTO `countries` VALUES (30, 'Bophuthatswana');
INSERT INTO `countries` VALUES (31, 'Bosnia-Herzegovina');
INSERT INTO `countries` VALUES (32, 'Botswana');
INSERT INTO `countries` VALUES (33, 'Bouvet Island');
INSERT INTO `countries` VALUES (34, 'Brazil');
INSERT INTO `countries` VALUES (35, 'British Indian Ocean');
INSERT INTO `countries` VALUES (36, 'British Virgin Islands');
INSERT INTO `countries` VALUES (37, 'Brunei Darussalam');
INSERT INTO `countries` VALUES (38, 'Bulgaria');
INSERT INTO `countries` VALUES (39, 'Burkina Faso');
INSERT INTO `countries` VALUES (40, 'Burundi');
INSERT INTO `countries` VALUES (41, 'Cambodia');
INSERT INTO `countries` VALUES (42, 'Cameroon');
INSERT INTO `countries` VALUES (44, 'Cape Verde Island');
INSERT INTO `countries` VALUES (45, 'Cayman Islands');
INSERT INTO `countries` VALUES (46, 'Central Africa');
INSERT INTO `countries` VALUES (47, 'Chad');
INSERT INTO `countries` VALUES (48, 'Channel Islands');
INSERT INTO `countries` VALUES (49, 'Chile');
INSERT INTO `countries` VALUES (50, 'China, Peoples Republic');
INSERT INTO `countries` VALUES (51, 'Christmas Island');
INSERT INTO `countries` VALUES (52, 'Cocos (Keeling) Islands');
INSERT INTO `countries` VALUES (53, 'Colombia');
INSERT INTO `countries` VALUES (54, 'Comoros Islands');
INSERT INTO `countries` VALUES (55, 'Congo');
INSERT INTO `countries` VALUES (56, 'Cook Islands');
INSERT INTO `countries` VALUES (57, 'Costa Rica');
INSERT INTO `countries` VALUES (58, 'Croatia');
INSERT INTO `countries` VALUES (59, 'Cuba');
INSERT INTO `countries` VALUES (60, 'Cyprus');
INSERT INTO `countries` VALUES (61, 'Czech Republic');
INSERT INTO `countries` VALUES (62, 'Denmark');
INSERT INTO `countries` VALUES (63, 'Djibouti');
INSERT INTO `countries` VALUES (64, 'Dominica');
INSERT INTO `countries` VALUES (65, 'Dominican Republic');
INSERT INTO `countries` VALUES (66, 'Easter Island');
INSERT INTO `countries` VALUES (67, 'Ecuador');
INSERT INTO `countries` VALUES (68, 'Egypt');
INSERT INTO `countries` VALUES (69, 'El Salvador');
INSERT INTO `countries` VALUES (70, 'England');
INSERT INTO `countries` VALUES (71, 'Equatorial Guinea');
INSERT INTO `countries` VALUES (72, 'Estonia');
INSERT INTO `countries` VALUES (73, 'Ethiopia');
INSERT INTO `countries` VALUES (74, 'Falkland Islands');
INSERT INTO `countries` VALUES (75, 'Faeroe Islands');
INSERT INTO `countries` VALUES (76, 'Fiji');
INSERT INTO `countries` VALUES (77, 'Finland');
INSERT INTO `countries` VALUES (78, 'France');
INSERT INTO `countries` VALUES (79, 'French Guyana');
INSERT INTO `countries` VALUES (80, 'French Polynesia');
INSERT INTO `countries` VALUES (81, 'Gabon');
INSERT INTO `countries` VALUES (82, 'Gambia');
INSERT INTO `countries` VALUES (83, 'Georgia Republic');
INSERT INTO `countries` VALUES (84, 'Germany');
INSERT INTO `countries` VALUES (85, 'Gibraltar');
INSERT INTO `countries` VALUES (86, 'Greece');
INSERT INTO `countries` VALUES (87, 'Greenland');
INSERT INTO `countries` VALUES (88, 'Grenada');
INSERT INTO `countries` VALUES (89, 'Guadeloupe (French)');
INSERT INTO `countries` VALUES (90, 'Guatemala');
INSERT INTO `countries` VALUES (91, 'Guernsey Island');
INSERT INTO `countries` VALUES (92, 'Guinea Bissau');
INSERT INTO `countries` VALUES (93, 'Guinea');
INSERT INTO `countries` VALUES (94, 'Guyana');
INSERT INTO `countries` VALUES (95, 'Haiti');
INSERT INTO `countries` VALUES (96, 'Heard and McDonald Isls');
INSERT INTO `countries` VALUES (97, 'Honduras');
INSERT INTO `countries` VALUES (98, 'Hong Kong');
INSERT INTO `countries` VALUES (99, 'Hungary');
INSERT INTO `countries` VALUES (100, 'Iceland');
INSERT INTO `countries` VALUES (101, 'India');
INSERT INTO `countries` VALUES (102, 'Iran');
INSERT INTO `countries` VALUES (103, 'Iraq');
INSERT INTO `countries` VALUES (104, 'Ireland');
INSERT INTO `countries` VALUES (105, 'Isle of Man');
INSERT INTO `countries` VALUES (106, 'Israel');
INSERT INTO `countries` VALUES (107, 'Italy');
INSERT INTO `countries` VALUES (108, 'Ivory Coast');
INSERT INTO `countries` VALUES (109, 'Jamaica');
INSERT INTO `countries` VALUES (110, 'Japan');
INSERT INTO `countries` VALUES (111, 'Jersey Island');
INSERT INTO `countries` VALUES (112, 'Jordan');
INSERT INTO `countries` VALUES (113, 'Kazakhstan');
INSERT INTO `countries` VALUES (114, 'Kenya');
INSERT INTO `countries` VALUES (115, 'Kiribati');
INSERT INTO `countries` VALUES (116, 'Kuwait');
INSERT INTO `countries` VALUES (117, 'Laos');
INSERT INTO `countries` VALUES (118, 'Latvia');
INSERT INTO `countries` VALUES (119, 'Lebanon');
INSERT INTO `countries` VALUES (120, 'Lesotho');
INSERT INTO `countries` VALUES (121, 'Liberia');
INSERT INTO `countries` VALUES (122, 'Libya');
INSERT INTO `countries` VALUES (123, 'Liechtenstein');
INSERT INTO `countries` VALUES (124, 'Lithuania');
INSERT INTO `countries` VALUES (125, 'Luxembourg');
INSERT INTO `countries` VALUES (126, 'Macao');
INSERT INTO `countries` VALUES (127, 'Macedonia');
INSERT INTO `countries` VALUES (128, 'Madagascar');
INSERT INTO `countries` VALUES (129, 'Malawi');
INSERT INTO `countries` VALUES (130, 'Malaysia');
INSERT INTO `countries` VALUES (131, 'Maldives');
INSERT INTO `countries` VALUES (132, 'Mali');
INSERT INTO `countries` VALUES (133, 'Malta');
INSERT INTO `countries` VALUES (134, 'Martinique (French)');
INSERT INTO `countries` VALUES (135, 'Mauritania');
INSERT INTO `countries` VALUES (136, 'Mauritius');
INSERT INTO `countries` VALUES (137, 'Mayotte');
INSERT INTO `countries` VALUES (139, 'Micronesia');
INSERT INTO `countries` VALUES (140, 'Moldavia');
INSERT INTO `countries` VALUES (141, 'Monaco');
INSERT INTO `countries` VALUES (142, 'Mongolia');
INSERT INTO `countries` VALUES (143, 'Montenegro');
INSERT INTO `countries` VALUES (144, 'Montserrat');
INSERT INTO `countries` VALUES (145, 'Morocco');
INSERT INTO `countries` VALUES (146, 'Mozambique');
INSERT INTO `countries` VALUES (147, 'Myanmar');
INSERT INTO `countries` VALUES (148, 'Namibia');
INSERT INTO `countries` VALUES (149, 'Nauru');
INSERT INTO `countries` VALUES (150, 'Nepal');
INSERT INTO `countries` VALUES (151, 'Netherlands Antilles');
INSERT INTO `countries` VALUES (152, 'Netherlands');
INSERT INTO `countries` VALUES (153, 'New Caledonia (French)');
INSERT INTO `countries` VALUES (154, 'New Zealand');
INSERT INTO `countries` VALUES (155, 'Nicaragua');
INSERT INTO `countries` VALUES (156, 'Niger');
INSERT INTO `countries` VALUES (157, 'Niue');
INSERT INTO `countries` VALUES (158, 'Norfolk Island');
INSERT INTO `countries` VALUES (159, 'North Korea');
INSERT INTO `countries` VALUES (160, 'Northern Ireland');
INSERT INTO `countries` VALUES (161, 'Norway');
INSERT INTO `countries` VALUES (162, 'Oman');
INSERT INTO `countries` VALUES (163, 'Pakistan');
INSERT INTO `countries` VALUES (164, 'Panama');
INSERT INTO `countries` VALUES (165, 'Papua New Guinea');
INSERT INTO `countries` VALUES (166, 'Paraguay');
INSERT INTO `countries` VALUES (167, 'Peru');
INSERT INTO `countries` VALUES (168, 'Philippines');
INSERT INTO `countries` VALUES (169, 'Pitcairn Island');
INSERT INTO `countries` VALUES (170, 'Poland');
INSERT INTO `countries` VALUES (171, 'Polynesia (French)');
INSERT INTO `countries` VALUES (172, 'Portugal');
INSERT INTO `countries` VALUES (173, 'Qatar');
INSERT INTO `countries` VALUES (174, 'Reunion Island');
INSERT INTO `countries` VALUES (175, 'Romania');
INSERT INTO `countries` VALUES (176, 'Russia');
INSERT INTO `countries` VALUES (177, 'Rwanda');
INSERT INTO `countries` VALUES (178, 'S.Georgia Sandwich Isls');
INSERT INTO `countries` VALUES (179, 'Sao Tome, Principe');
INSERT INTO `countries` VALUES (180, 'San Marino');
INSERT INTO `countries` VALUES (181, 'Saudi Arabia');
INSERT INTO `countries` VALUES (182, 'Scotland');
INSERT INTO `countries` VALUES (183, 'Senegal');
INSERT INTO `countries` VALUES (184, 'Serbia');
INSERT INTO `countries` VALUES (185, 'Seychelles');
INSERT INTO `countries` VALUES (186, 'Shetland');
INSERT INTO `countries` VALUES (187, 'Sierra Leone');
INSERT INTO `countries` VALUES (188, 'Singapore');
INSERT INTO `countries` VALUES (189, 'Slovak Republic');
INSERT INTO `countries` VALUES (190, 'Slovenia');
INSERT INTO `countries` VALUES (191, 'Solomon Islands');
INSERT INTO `countries` VALUES (192, 'Somalia');
INSERT INTO `countries` VALUES (193, 'South Africa');
INSERT INTO `countries` VALUES (194, 'South Korea');
INSERT INTO `countries` VALUES (195, 'Spain');
INSERT INTO `countries` VALUES (196, 'Sri Lanka');
INSERT INTO `countries` VALUES (197, 'St. Helena');
INSERT INTO `countries` VALUES (198, 'St. Lucia');
INSERT INTO `countries` VALUES (199, 'St. Pierre Miquelon');
INSERT INTO `countries` VALUES (200, 'St. Martins');
INSERT INTO `countries` VALUES (201, 'St. Kitts Nevis Anguilla');
INSERT INTO `countries` VALUES (202, 'St. Vincent Grenadines');
INSERT INTO `countries` VALUES (203, 'Sudan');
INSERT INTO `countries` VALUES (204, 'Suriname');
INSERT INTO `countries` VALUES (205, 'Svalbard Jan Mayen');
INSERT INTO `countries` VALUES (206, 'Swaziland');
INSERT INTO `countries` VALUES (207, 'Sweden');
INSERT INTO `countries` VALUES (208, 'Switzerland');
INSERT INTO `countries` VALUES (209, 'Syria');
INSERT INTO `countries` VALUES (210, 'Tajikistan');
INSERT INTO `countries` VALUES (211, 'Taiwan');
INSERT INTO `countries` VALUES (212, 'Tahiti');
INSERT INTO `countries` VALUES (213, 'Tanzania');
INSERT INTO `countries` VALUES (214, 'Thailand');
INSERT INTO `countries` VALUES (215, 'Togo');
INSERT INTO `countries` VALUES (216, 'Tokelau');
INSERT INTO `countries` VALUES (217, 'Tonga');
INSERT INTO `countries` VALUES (218, 'Trinidad and Tobago');
INSERT INTO `countries` VALUES (219, 'Tunisia');
INSERT INTO `countries` VALUES (220, 'Turkmenistan');
INSERT INTO `countries` VALUES (221, 'Turks and Caicos Isls');
INSERT INTO `countries` VALUES (222, 'Tuvalu');
INSERT INTO `countries` VALUES (223, 'Uganda');
INSERT INTO `countries` VALUES (224, 'Ukraine');
INSERT INTO `countries` VALUES (225, 'United Arab Emirates');
INSERT INTO `countries` VALUES (226, 'Uruguay');
INSERT INTO `countries` VALUES (227, 'Uzbekistan');
INSERT INTO `countries` VALUES (228, 'Vanuatu');
INSERT INTO `countries` VALUES (229, 'Vatican City State');
INSERT INTO `countries` VALUES (230, 'Venezuela');
INSERT INTO `countries` VALUES (231, 'Vietnam');
INSERT INTO `countries` VALUES (232, 'Virgin Islands (Brit)');
INSERT INTO `countries` VALUES (233, 'Wales');
INSERT INTO `countries` VALUES (234, 'Wallis Futuna Islands');
INSERT INTO `countries` VALUES (235, 'Western Sahara');
INSERT INTO `countries` VALUES (236, 'Western Samoa');
INSERT INTO `countries` VALUES (237, 'Yemen');
INSERT INTO `countries` VALUES (238, 'Yugoslavia');
INSERT INTO `countries` VALUES (239, 'Zaire');
INSERT INTO `countries` VALUES (240, 'Zambia');
INSERT INTO `countries` VALUES (241, 'Zimbabwe')
      END
    sql_code.split(';').each do |stmt|
      execute stmt
    end
  end

  def self.down
  end
end
